List of properties

Entity DEPayrollData
Key property ID


Property starting with A
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ActivityGroup Leistungsgruppe Stat. Landesamt Gewerblich Leistungsgruppe Stat. Landesamt Gewerblich String ActivityGroup

Property starting with B
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
BaseSalarySFN SFN-Grundlohn SFN-Grundlohn Number BaseSalarySFN
BaseSalarySFNFormula Kennzeichen Grundlohn Kennzeichen Grundlohn String BaseSalarySFNFormula
BenefitPaymentStartDate Beginn Versorgung Beginn Versorgung Date BenefitPaymentStartDate
BenefitPaymentThreshold Bemessung lfd. Bez. Bemessung lfd. Bez. Number BenefitPaymentThreshold
BenefitPaymentThresholdEGA Bemessung EGA Bemessung EGA Number BenefitPaymentThresholdEGA
BirthDate Date BirthDate

Property starting with C
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ChildFreeAmount Kinderfreibeträge Kinderfreibeträge Number ChildFreeAmount
ChildFreeAmountKUG Abw. Kinderfreibeträge Abw. Kinderfreibeträge Number ChildFreeAmountKUG
ChildrenExtraPremium zusätzl. PV zusätzl. PV Boolean ChildrenExtraPremium
CompanyCode String CompanyCode
Contract Contract Contract Number Contract
ContractDescription String ContractDescription
ContractPaymentPeriod String ContractPaymentPeriod
CostCenter String CostCenter
CountryCode Country Country String CountryCode
CreatedDate Date CreatedDate
Creator Number Creator
CreatorName String CreatorName
CreditorNumber String CreditorNumber

Property starting with D
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Denomination Konfession Arbeitnehmer Konfession Arbeitnehmer String Denomination
DenominationPartner Konfession Ehegatte Konfession Ehegatte String DenominationPartner
Description Description Description String Description
DEUEVStatus DEÜV-Status DEÜV-Status String DEUEVStatus
DeviatingMaxTaxtableAmount Abweichende Beitragsgrenze Abweichende Beitragsgrenze String DeviatingMaxTaxtableAmount

Property starting with E
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
EmploymentGroup Arbeitnehmergruppe Arbeitnehmergruppe String EmploymentGroup
EmploymentStart Date EmploymentStart
EmploymentType Beschäftigungsart Beschäftigungsart String EmploymentType
EndDate Date EndDate

Property starting with F
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
FlatChurchTax keine Pauschale Kist keine Pauschale Kist Boolean FlatChurchTax
FlatTaxDescription String FlatTaxDescription
FlatTaxNumber Pauschalsteuersatz Pauschalsteuersatz String FlatTaxNumber

Property starting with H
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
HealthCareTypeDeviating Private/freiwillige KV Private/freiwillige KV String HealthCareTypeDeviating
HealthCareTypePrivate PKV Gesamtbeitrag PKV Gesamtbeitrag Number HealthCareTypePrivate

Property starting with I
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ID Number ID

Property starting with M
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
MaritalStatus String MaritalStatus
ModifiedDate Date ModifiedDate
Modifier Number Modifier
ModifierName String ModifierName
MultipleEmploymentType Mehrfachbeschäftigt Mehrfachbeschäftigt String MultipleEmploymentType

Property starting with N
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
NonTaxableAmountMonth Freibetrag monatlich Freibetrag monatlich Number NonTaxableAmountMonth
NonTaxableAmountYear Freibetrag jährlich Freibetrag jährlich Number NonTaxableAmountYear
NursingInsuranceTypeDeviating Private/freiwillige PV Private/freiwillige PV String NursingInsuranceTypeDeviating
NursingInsuranceTypePrivate PPV Gesamtbeitrag PPV Gesamtbeitrag Number NursingInsuranceTypePrivate

Property starting with O
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
OvertimePercentage Überstunden %-Satz Überstunden %-Satz Number OvertimePercentage

Property starting with P
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
PaymentPeriod Payment period Payment period String PaymentPeriod
Period Period Period Number Period
PlannedRemunerationAmount Sollentgelt Sollentgelt Number PlannedRemunerationAmount
PlannedRemunerationComponent LA Soll-Entgelt LA Soll-Entgelt String PlannedRemunerationComponent
PlannedRemunerationComponentDescription String PlannedRemunerationComponentDescription
PlannedRemunerationType Sollentgelt Art Sollentgelt Art String PlannedRemunerationType

Property starting with R
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ResourceCostCenter Cost center Cost center String ResourceCostCenter
ResourceID Resource Resource Number ResourceID
ResourceName String ResourceName
RetirementPay Rentenantrag/-bezug Rentenantrag/-bezug String RetirementPay
RetirementPayMaxAmount Maximale BBG Rentner Maximale BBG Rentner Number RetirementPayMaxAmount

Property starting with S
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
SocialInsuranceInterruption Status (Sperrkennzeichen) Status (Sperrkennzeichen) Boolean SocialInsuranceInterruption
SocialInsuranceType SV-Kennzeichen SV-Kennzeichen String SocialInsuranceType
SocialSecurityGroup Beitragsgruppe Beitragsgruppe String SocialSecurityGroup
SocialSecurityGroupEmployer Übernahme SV-Beiträge Übernahme SV-Beiträge String SocialSecurityGroupEmployer
SocialSecurityNumber String SocialSecurityNumber
SpecialTaxDeclaration Besondere Lst-Bescheinigung Besondere Lst-Bescheinigung Boolean SpecialTaxDeclaration
StartDate Date StartDate
State Bundesland Bundesland String State

Property starting with T
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
TariffStartDate Einstufungsdatum Einstufungsdatum Date TariffStartDate
TaxClass Steuerklasse Steuerklasse Number TaxClass
TaxClassKUG Abw. Steuerklasse Abw. Steuerklasse Number TaxClassKUG
TaxTable Lohnsteuertabelle Lohnsteuertabelle String TaxTable
Type Type Type String Type

Property starting with W
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
WorkingChamberLand Arbeitskammer Arbeitskammer String WorkingChamberLand

Property starting with Y
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
YearlySalary Vorauss. Jahreseinkommen Vorauss. Jahreseinkommen Number YearlySalary
YearlyTaxRefund Lohnsteuerjahresausgleich Lohnsteuerjahresausgleich Boolean YearlyTaxRefund

Detail information of properties

Property starting with A
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ActivityGroup Leistungsgruppe String 1 0 _
Exact.Repository.ERSelectionValue

Property starting with B
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
BaseSalarySFN GrundlohnSFN Number 11 2 0
BaseSalarySFNFormula GrundlohnSFNFormel String 1 0 0
Exact.Repository.ERSelectionValue
BenefitPaymentStartDate VersorgungBeginn Date 0 0
BenefitPaymentThreshold VersorgungBemessungLfd Number 11 2 0
BenefitPaymentThresholdEGA VersorgungBemessungEGA Number 11 2 0
BirthDate BirthDate Date 8 0

Property starting with C
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ChildFreeAmount Kinderfreibetrag Number 4 1 0
ChildFreeAmountKUG KinderfreibetragKUG Number 4 1 0
ChildrenExtraPremium KinderPV Boolean 0 0 1
CompanyCode CompanyCode String 3 0
Contract Contract Number 2 0
ContractDescription ContractDescription String 50 0
ContractPaymentPeriod ContractPaymentPeriod String 1 0 M
Exact.Repository.ERSelectionValue
CostCenter CostCenter String 8 0
CountryCode CountryCode String 3 0 DE
CreatedDate Created Date 12 0 NOW
Creator Creator Number 10 0
CreatorName CreatorName String 64 0
CreditorNumber CreditorNumber String 6 0

Property starting with D
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Denomination Konfession String 1 0 0
Exact.Repository.ERSelectionValue
DenominationPartner KonfessionEhegatte String 1 0 0
Exact.Repository.ERSelectionValue
Description Description String 50 0 Gehaltsdaten
DEUEVStatus DEUEVStatus String 1 0 _
Exact.Repository.ERSelectionValue
DeviatingMaxTaxtableAmount BeitragsgrenzeAbweichung String 1 0 0
Exact.Repository.ERSelectionValue

Property starting with E
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
EmploymentGroup Arbeitnehmergruppe String 1 0 A
Exact.Repository.ERSelectionValue
EmploymentStart EmploymentStart Date 8 0
EmploymentType Beschaeftigungsart String 1 0 _
Exact.Repository.ERSelectionValue
EndDate EndDate Date 0 0

Property starting with F
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
FlatChurchTax PauschaleKist Boolean 0 0 0
FlatTaxDescription PauschalsteuersatzDescription String 50 0
FlatTaxNumber Pauschalsteuersatz String 8 0

Property starting with H
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
HealthCareTypeDeviating KrankenversicherungFreiwillig String 1 0 _
Exact.Repository.ERSelectionValue
HealthCareTypePrivate KrankenversicherungPrivat Number 11 2 0

Property starting with I
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ID ID Number 10 0

Property starting with M
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
MaritalStatus MaritalStatus String 1 0
ModifiedDate Modified Date 12 0 NOW
Modifier Modifier Number 10 0
ModifierName ModifierName String 64 0
MultipleEmploymentType MehrfachBeschaeftigt String 1 0 N
Exact.Repository.ERSelectionValue

Property starting with N
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
NonTaxableAmountMonth FreibetragMonat Number 11 2 0
NonTaxableAmountYear FreibetragJahr Number 11 2 0
NursingInsuranceTypeDeviating PflegeversicherungFreiwillig String 1 0 0
Exact.Repository.ERSelectionValue
NursingInsuranceTypePrivate PflegeversicherungPrivat Number 11 2 0

Property starting with O
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
OvertimePercentage UeberstundenProzent Number 8 4 0

Property starting with P
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
PaymentPeriod PaymentPeriod String 1 0 M
Exact.Repository.ERSelectionValue
Period Period Number 4 0 0
PlannedRemunerationAmount SollentgeltBetrag Number 11 2 0
PlannedRemunerationComponent SollentgeltLohnart String 8 0
PlannedRemunerationComponentDescription SollentgeltLohnartDescription String 50 0
PlannedRemunerationType SollentgeltArt String 1 0 0
Exact.Repository.ERSelectionValue

Property starting with R
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ResourceCostCenter ResourceCostCenter String 8 0
ResourceID ResourceID Number 10 0
ResourceName ResourceName String 64 0
RetirementPay RentenBezug String 1 0 0
Exact.Repository.ERSelectionValue
RetirementPayMaxAmount RentenZuverdienstgrenze Number 11 2 0

Property starting with S
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
SocialInsuranceInterruption SVUnterbrechung Boolean 0 0 0
SocialInsuranceType SVKennzeichen String 1 0 0
Exact.Repository.ERSelectionValue
SocialSecurityGroup Beitragsgruppe String 4 0 0000 0123456789
SocialSecurityGroupEmployer UebernahmeSVAG String 4 0 0000 01
SocialSecurityNumber SocialSecurityNumber String 50 0
SpecialTaxDeclaration Lohnsteuerbescheinigung Boolean 0 0 0
StartDate StartDate Date 0 0
State Bundesland String 1 0 0
Exact.Repository.ERSelectionValue

Property starting with T
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
TariffStartDate Einstufungsdatum Date 8 0
TaxClass Steuerklasse Number 1 0 0 6
TaxClassKUG SteuerklasseKUG Number 1 0 0 6
TaxTable Lohnsteuertabelle String 1 0 N
Exact.Repository.ERSelectionValue
Type Type String 1 0 P

Property starting with W
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
WorkingChamberLand ArbeitskammerLand String 1 0 _
Exact.Repository.ERSelectionValue

Property starting with Y
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
YearlySalary Jahreseinkommen Number 11 2 0
YearlyTaxRefund Lohnsteuerjahresausgleich Boolean 0 0 1

List of obsolete properties
There is no obsolete property